﻿CREATE TABLE [dbo].[Login] (
    [LoginId]    INT             IDENTITY (1, 1) NOT NULL,
    [Name]       VARCHAR (4000)   NULL,
    [SID]        VARBINARY (100) NULL,
    [CreateDate] DATETIME        NULL,
    [Enabled]    BIT             NULL,
    [ServiceId]  INT             NOT NULL,
    CONSTRAINT [PK_Login] PRIMARY KEY CLUSTERED ([LoginId] ASC),
    CONSTRAINT [FK_Login_Service] FOREIGN KEY ([ServiceId]) REFERENCES [dbo].[Service] ([ServiceID])
);

